<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>

<%
    //得到用户输入的信息
    String username=request.getParameter("username");
    String password=request.getParameter("password");
    //3+1
    Connection connection=null;
    Statement statement=null;
    String sql="insert into t_users(username,password) " +
            "values('"+username+"','"+password+"')";
    //二二一，两个双引号，两个加号，一个变量
    Class.forName("com.mysql.jdbc.Driver");
    //加载驱动程序
    connection= DriverManager.getConnection(
            "jdbc:mysql://localhost:3306" +
                    "/sctu_javaweb_2018?" +
                    "serverTimezone=UTC",
            "root",
            "123456"
    );


    statement = connection.createStatement();
    statement.execute(sql);
    out.write("<h1>成功添加用户!</h1>" );
    out.write("<a href='userList.jsp'>返回首页</a>");

%>
</body>
</html>
